Today's Question:  What does your personal desk look like?        GIVE A SHOUT

SEARCH KEYWORD -- Concurrent connection limit

  Why (offset, limit) is slow in database select?

Starting from a problem Five years ago when I was working at Tencent, I found that MySQL request speed was very slow in the pagination scenario. With only 100,000 data, a select query on a single machine took about 2-3 seconds. I asked my mentor why, and he asked in return, "In an indexing scenario, what is the time complexity to get the nth largest number in MySQL?" The pursuit of the answer Confirming the scenario Assuming there is an index on the "status" column, a query like "select * from t...

   SLOW,LIMIT,OFFSET,MYSQL     2023-03-12 05:21:02

  How to check a port is taken by which program on Linux

Lots of you may have encountered some error message stating that the port has been taken by another program while trying to start a program on Linux. And you would want to know which program takes the port you want to use. This post will provide some feasible ways to check out which program is taking a specific port. lsof -i:[port] lsof is the command to list open files on Linux. And if you know more about Linux you should get to know everything on Linux is a file even including networ...

   LINUX,PORT,NETSTAT,LSOF     2018-08-12 04:27:57

  Privileged users get removed from database in GoDaddy shared hosting

GaDaddy is a famous web hosting platform where many people put their websites on its platform. If one has low budget and wanna a shared hosting, you can buy the service at GoDaddy and share some hosting resource with others. In such cases, there would be resource limit based on different plans. In this post, we will discuss one scenario which caused our application down caused by database usage on shared hosting plan and hope it helps readers who encounter similar issues. The issue we encounter...

   CPANEL,DATABASE,GODADDY,PRIVILEGED USER     2021-05-25 23:06:50

  10 Best Android Apps of 2016

The year 2016 has been gone with all its good and bad memories. But in the field of information technology, this year was another boost in which the field rapidly grew and explores some more essentials for the ease of users. In the field of mobile apps, specially users of Android OS, the year 2016 was awesome because in this year, they got many useful apps created by the highly qualified app developers of the world.Experts of Android OS rounded up a lot of apps created in the year 2016 and they ...

   MOBILE APP DEVELOPMENT COMPANY,CUSTOM MOBILE APP DEVELOPMENT COMPANY     2017-01-10 14:07:32

RECENT